2015-03-10 - 17763 - Break Fix - Retail and Intercompany showing all cust #BExQueriesforCrystalReportsAnalysisTool

17763

Break Fix - Retail and Inter company showing all cust

Problem Summary

---

Sales Analysis Retail and Intercompany reports showing all intercompany customers.

Admin Info

---

Purpose	Need to check the Sales Analysis and Intercompany customer reports & make necessary changes.
Requested by	Mark Harris
Issue Date	10-03-2015
Resolved by	Naveen G
Resolved Date	10-04-2015
Document Status	Complete

Detailed Problem Description

---

Email from Mark.G:
Could you please have a member of your team validate that the correct inclusions are being applied to the Regional Sales Analysis Retail and Intercompany Analysis Queries and make the necessary changes?
We had checked the EMEA & Japan versions of this query and they were showing all customers.

Solution Analysis and Recommendations

---

It was observed that in sales analysis retail and intercompany analysis reports all the intercompany customers from all regions are excluded for all the regions due to which the reports are showing data for all the customers.

Resolution

---

1. Need to remove all 53 exclusions for 0CUSTOMER infoobject.
2. Need to include all the 46 intercompany customers.

Release Information

---

2015-03-10 - 17763 - Rel Notes - Retail and Intercompany showing all cust